Overview
Brought to you by YData
Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 19096 |
| Missing cells | 138 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 14.0 MiB |
| Average record size in memory | 770.0 B |
Variable types
| Numeric | 7 |
|---|---|
| Text | 4 |
| Categorical | 4 |
| DateTime | 3 |
| Unsupported | 2 |
discount_amount is highly overall correlated with order_id and 1 other fields | High correlation |
order_id is highly overall correlated with discount_amount and 1 other fields | High correlation |
ticket_id is highly overall correlated with discount_amount and 1 other fields | High correlation |
passenger_age is highly skewed (γ1 = 138.1694074) | Skewed |
insurance_fee is highly skewed (γ1 = 20.20000787) | Skewed |
ticket_id has unique values | Unique |
departure_time is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
arrival_time is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
baggage has 17290 (90.5%) zeros | Zeros |
insurance_fee has 19053 (99.8%) zeros | Zeros |
discount_amount has 6561 (34.4%) zeros | Zeros |
Reproduction
| Analysis started | 2025-04-27 08:56:55.524048 |
|---|---|
| Analysis finished | 2025-04-27 08:57:02.416960 |
| Duration | 6.89 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
order_id
Real number (ℝ)
High correlation
| Distinct | 12422 |
|---|---|
| Distinct (%) | 65.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26922.722 |
| Minimum | 20142 |
|---|---|
| Maximum | 33943 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.3 KiB |
Quantile statistics
| Minimum | 20142 |
|---|---|
| 5-th percentile | 20786 |
| Q1 | 23431.75 |
| median | 26826 |
| Q3 | 30361.25 |
| 95-th percentile | 33272.5 |
| Maximum | 33943 |
| Range | 13801 |
| Interquartile range (IQR) | 6929.5 |
Descriptive statistics
| Standard deviation | 3999.9958 |
|---|---|
| Coefficient of variation (CV) | 0.14857323 |
| Kurtosis | -1.1952913 |
| Mean | 26922.722 |
| Median Absolute Deviation (MAD) | 3460.5 |
| Skewness | 0.049492992 |
| Sum | 5.1411631 × 108 |
| Variance | 15999966 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 28302 | 16 | 0.1% |
| 26506 | 16 | 0.1% |
| 26503 | 15 | 0.1% |
| 27048 | 15 | 0.1% |
| 28301 | 15 | 0.1% |
| 24734 | 13 | 0.1% |
| 30579 | 13 | 0.1% |
| 21642 | 12 | 0.1% |
| 24219 | 12 | 0.1% |
| 21026 | 12 | 0.1% |
| Other values (12412) | 18957 |
| Value | Count | Frequency (%) |
| 20142 | 2 | |
| 20143 | 2 | |
| 20144 | 2 | |
| 20145 | 2 | |
| 20146 | 1 | < 0.1% |
| 20147 | 2 | |
| 20148 | 1 | < 0.1% |
| 20149 | 2 | |
| 20150 | 2 | |
| 20151 | 3 |
| Value | Count | Frequency (%) |
| 33943 | 1 | < 0.1% |
| 33942 | 1 | < 0.1% |
| 33941 | 1 | < 0.1% |
| 33940 | 2 | < 0.1% |
| 33939 | 1 | < 0.1% |
| 33938 | 1 | < 0.1% |
| 33935 | 3 | < 0.1% |
| 33934 | 2 | < 0.1% |
| 33929 | 8 | |
| 33928 | 1 | < 0.1% |
ticket_id
Real number (ℝ)
High correlation Unique
| Distinct | 19096 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41841.328 |
| Minimum | 31164 |
|---|---|
| Maximum | 52769 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.3 KiB |
Quantile statistics
| Minimum | 31164 |
|---|---|
| 5-th percentile | 32228.75 |
| Q1 | 36484.75 |
| median | 41807.5 |
| Q3 | 47093.25 |
| 95-th percentile | 51687.5 |
| Maximum | 52769 |
| Range | 21605 |
| Interquartile range (IQR) | 10608.5 |
Descriptive statistics
| Standard deviation | 6199.5059 |
|---|---|
| Coefficient of variation (CV) | 0.14816704 |
| Kurtosis | -1.1743666 |
| Mean | 41841.328 |
| Median Absolute Deviation (MAD) | 5305.5 |
| Skewness | 0.027185024 |
| Sum | 7.99002 × 108 |
| Variance | 38433873 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 52669 | 1 | < 0.1% |
| 31268 | 1 | < 0.1% |
| 31242 | 1 | < 0.1% |
| 31337 | 1 | < 0.1% |
| 31360 | 1 | < 0.1% |
| 31355 | 1 | < 0.1% |
| 31348 | 1 | < 0.1% |
| 31307 | 1 | < 0.1% |
| 52602 | 1 | < 0.1% |
| 52677 | 1 | < 0.1% |
| Other values (19086) | 19086 |
| Value | Count | Frequency (%) |
| 31164 | 1 | |
| 31165 | 1 | |
| 31166 | 1 | |
| 31167 | 1 | |
| 31168 | 1 | |
| 31169 | 1 | |
| 31170 | 1 | |
| 31171 | 1 | |
| 31172 | 1 | |
| 31173 | 1 |
| Value | Count | Frequency (%) |
| 52769 | 1 | |
| 52767 | 1 | |
| 52766 | 1 | |
| 52764 | 1 | |
| 52763 | 1 | |
| 52761 | 1 | |
| 52760 | 1 | |
| 52754 | 1 | |
| 52753 | 1 | |
| 52752 | 1 |
passenger_id
Text
| Distinct | 5282 |
|---|---|
| Distinct (%) | 27.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
Length
| Max length | 44 |
|---|---|
| Median length | 44 |
| Mean length | 44 |
| Min length | 44 |
Unique
| Unique | 1975 ? |
|---|---|
| Unique (%) | 10.3% |
Sample
| 1st row | Xs1fLinPQun+Oy/mD0FlfXMyJD38YlXJfXNbz+qO+5U= |
|---|---|
| 2nd row | m/auVlEoaGSe2MqR/Lq4CFXJnI8zauNyF/KiFmMgXHs= |
| 3rd row | 6HvtV2vTqUfNBJ53C4TzvJnb0s74KgcRNuUVS+8jRvU= |
| 4th row | WiK2P31WEd4mckRNVWz0C2aKKRgSrauAG8NdfTLnKjE= |
| 5th row | 6HvtV2vTqUfNBJ53C4TzvJnb0s74KgcRNuUVS+8jRvU= |
| Value | Count | Frequency (%) |
| 7mhtyxxvgw06awi7uyjjojbxcnsaz7ivqkkpa3oc4zm | 588 | 3.1% |
| rtw0btvvqbxqizvebr6hh/j9god8piy3mdszo+vozcq | 341 | 1.8% |
| i0eiiyr+5um9iesxjj9fgunnnjnap0dqagpbsjpwp/a | 125 | 0.7% |
| vi/lz6sujqxtp1msegaa/3egypfm0aavgs/tqf6xcwi | 112 | 0.6% |
| tx4mtskll4v/ooar52nfe28fezyzbmhfjuobbepm1xs | 92 | 0.5% |
| mjy6huul7qyrs4yyrtpg4se3c+t83gwxusqbxl0jngy | 88 | 0.5% |
| xcghxo/oo7jui6xnb7jj+j1p0m5f9cseitx/3aqswbo | 73 | 0.4% |
| soiaevbvr7zq5d3+iblzf+pvx6u9kcchbwmiue3vwyg | 72 | 0.4% |
| f93nlcwewdxp8ti0zn3sqdbwxrhtlbixyukkcztsfvi | 70 | 0.4% |
| ngq3kueexa/xfmxabympo/3edazikvbgaxiawfv60x4 | 52 | 0.3% |
| Other values (5272) | 17483 |
Most occurring characters
| Value | Count | Frequency (%) |
| = | 19096 | 2.3% |
| A | 14821 | 1.8% |
| M | 14758 | 1.8% |
| I | 14664 | 1.7% |
| o | 14652 | 1.7% |
| 0 | 14530 | 1.7% |
| g | 13951 | 1.7% |
| X | 13902 | 1.7% |
| 7 | 13886 | 1.7% |
| c | 13777 | 1.6% |
| Other values (55) | 692187 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 840224 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| = | 19096 | 2.3% |
| A | 14821 | 1.8% |
| M | 14758 | 1.8% |
| I | 14664 | 1.7% |
| o | 14652 | 1.7% |
| 0 | 14530 | 1.7% |
| g | 13951 | 1.7% |
| X | 13902 | 1.7% |
| 7 | 13886 | 1.7% |
| c | 13777 | 1.6% |
| Other values (55) | 692187 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 840224 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| = | 19096 | 2.3% |
| A | 14821 | 1.8% |
| M | 14758 | 1.8% |
| I | 14664 | 1.7% |
| o | 14652 | 1.7% |
| 0 | 14530 | 1.7% |
| g | 13951 | 1.7% |
| X | 13902 | 1.7% |
| 7 | 13886 | 1.7% |
| c | 13777 | 1.6% |
| Other values (55) | 692187 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 840224 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| = | 19096 | 2.3% |
| A | 14821 | 1.8% |
| M | 14758 | 1.8% |
| I | 14664 | 1.7% |
| o | 14652 | 1.7% |
| 0 | 14530 | 1.7% |
| g | 13951 | 1.7% |
| X | 13902 | 1.7% |
| 7 | 13886 | 1.7% |
| c | 13777 | 1.6% |
| Other values (55) | 692187 |
passenger_gender
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 13 |
| Missing (%) | 0.1% |
| Memory size | 1008.1 KiB |
| Female | |
|---|---|
| Male |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.050883 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Female |
|---|---|
| 2nd row | Female |
| 3rd row | Female |
| 4th row | Male |
| 5th row | Female |
Common Values
| Value | Count | Frequency (%) |
| Female | 10027 | |
| Male | 9056 | |
| (Missing) | 13 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| female | 10027 | |
| male | 9056 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 29110 | |
| a | 19083 | |
| l | 19083 | |
| F | 10027 | 10.4% |
| m | 10027 | 10.4% |
| M | 9056 | 9.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 96386 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 29110 | |
| a | 19083 | |
| l | 19083 | |
| F | 10027 | 10.4% |
| m | 10027 | 10.4% |
| M | 9056 | 9.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 96386 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 29110 | |
| a | 19083 | |
| l | 19083 | |
| F | 10027 | 10.4% |
| m | 10027 | 10.4% |
| M | 9056 | 9.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 96386 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 29110 | |
| a | 19083 | |
| l | 19083 | |
| F | 10027 | 10.4% |
| m | 10027 | 10.4% |
| M | 9056 | 9.4% |
passenger_age
Real number (ℝ)
Skewed
| Distinct | 92 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 5 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 82.64093 |
| Minimum | -1 |
|---|---|
| Maximum | 999999 |
| Zeros | 25 |
| Zeros (%) | 0.1% |
| Negative | 2 |
| Negative (%) | < 0.1% |
| Memory size | 149.3 KiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 22 |
| median | 28 |
| Q3 | 36 |
| 95-th percentile | 59 |
| Maximum | 999999 |
| Range | 1000000 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 7237.2387 |
|---|---|
| Coefficient of variation (CV) | 87.574507 |
| Kurtosis | 19090.857 |
| Mean | 82.64093 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 138.16941 |
| Sum | 1577698 |
| Variance | 52377624 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 26 | 950 | 5.0% |
| 29 | 947 | 5.0% |
| 23 | 946 | 5.0% |
| 30 | 923 | 4.8% |
| 24 | 917 | 4.8% |
| 27 | 846 | 4.4% |
| 22 | 838 | 4.4% |
| 19 | 801 | 4.2% |
| 20 | 795 | 4.2% |
| 21 | 771 | 4.0% |
| Other values (82) | 10357 |
| Value | Count | Frequency (%) |
| -1 | 2 | < 0.1% |
| 0 | 25 | 0.1% |
| 1 | 121 | |
| 2 | 222 | |
| 3 | 129 | |
| 4 | 123 | |
| 5 | 145 | |
| 6 | 116 | |
| 7 | 71 | 0.4% |
| 8 | 115 |
| Value | Count | Frequency (%) |
| 999999 | 1 | < 0.1% |
| 115 | 1 | < 0.1% |
| 91 | 3 | < 0.1% |
| 90 | 3 | < 0.1% |
| 87 | 5 | |
| 86 | 1 | < 0.1% |
| 85 | 8 | |
| 84 | 5 | |
| 83 | 5 | |
| 82 | 9 |
ticket_source_name
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 988.2 KiB |
| IOS | |
|---|---|
| Android | |
| GYL |
Length
| Max length | 7 |
|---|---|
| Median length | 3 |
| Mean length | 3.9844994 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | IOS |
|---|---|
| 2nd row | GYL |
| 3rd row | IOS |
| 4th row | Android |
| 5th row | IOS |
Common Values
| Value | Count | Frequency (%) |
| IOS | 12369 | |
| Android | 4700 | 24.6% |
| GYL | 2027 | 10.6% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| ios | 12369 | |
| android | 4700 | 24.6% |
| gyl | 2027 | 10.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| I | 12369 | |
| O | 12369 | |
| S | 12369 | |
| d | 9400 | |
| A | 4700 | 6.2% |
| n | 4700 | 6.2% |
| r | 4700 | 6.2% |
| o | 4700 | 6.2% |
| i | 4700 | 6.2% |
| G | 2027 | 2.7% |
| Other values (2) | 4054 | 5.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 76088 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| I | 12369 | |
| O | 12369 | |
| S | 12369 | |
| d | 9400 | |
| A | 4700 | 6.2% |
| n | 4700 | 6.2% |
| r | 4700 | 6.2% |
| o | 4700 | 6.2% |
| i | 4700 | 6.2% |
| G | 2027 | 2.7% |
| Other values (2) | 4054 | 5.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 76088 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| I | 12369 | |
| O | 12369 | |
| S | 12369 | |
| d | 9400 | |
| A | 4700 | 6.2% |
| n | 4700 | 6.2% |
| r | 4700 | 6.2% |
| o | 4700 | 6.2% |
| i | 4700 | 6.2% |
| G | 2027 | 2.7% |
| Other values (2) | 4054 | 5.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 76088 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| I | 12369 | |
| O | 12369 | |
| S | 12369 | |
| d | 9400 | |
| A | 4700 | 6.2% |
| n | 4700 | 6.2% |
| r | 4700 | 6.2% |
| o | 4700 | 6.2% |
| i | 4700 | 6.2% |
| G | 2027 | 2.7% |
| Other values (2) | 4054 | 5.3% |
ticket_status
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 978.6 KiB |
| New | |
|---|---|
| Paid | |
| Cancel | 159 |
Length
| Max length | 6 |
|---|---|
| Median length | 3 |
| Mean length | 3.4719837 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Paid |
|---|---|
| 2nd row | Paid |
| 3rd row | Paid |
| 4th row | New |
| 5th row | Paid |
Common Values
| Value | Count | Frequency (%) |
| New | 10401 | |
| Paid | 8536 | |
| Cancel | 159 | 0.8% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| new | 10401 | |
| paid | 8536 | |
| cancel | 159 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 10560 | |
| N | 10401 | |
| w | 10401 | |
| a | 8695 | |
| P | 8536 | |
| i | 8536 | |
| d | 8536 | |
| C | 159 | 0.2% |
| n | 159 | 0.2% |
| c | 159 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 66301 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 10560 | |
| N | 10401 | |
| w | 10401 | |
| a | 8695 | |
| P | 8536 | |
| i | 8536 | |
| d | 8536 | |
| C | 159 | 0.2% |
| n | 159 | 0.2% |
| c | 159 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 66301 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 10560 | |
| N | 10401 | |
| w | 10401 | |
| a | 8695 | |
| P | 8536 | |
| i | 8536 | |
| d | 8536 | |
| C | 159 | 0.2% |
| n | 159 | 0.2% |
| c | 159 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 66301 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 10560 | |
| N | 10401 | |
| w | 10401 | |
| a | 8695 | |
| P | 8536 | |
| i | 8536 | |
| d | 8536 | |
| C | 159 | 0.2% |
| n | 159 | 0.2% |
| c | 159 | 0.2% |
created_date
Date
| Distinct | 92 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.3 KiB |
| Minimum | 2023-03-01 00:00:00 |
|---|---|
| Maximum | 2023-05-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
departure_date
Date
| Distinct | 188 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.3 KiB |
| Minimum | 2023-03-01 00:00:00 |
|---|---|
| Maximum | 2024-01-26 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
departure_time
Unsupported
Rejected Unsupported
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 895.3 KiB |
arrival_date
Date
| Distinct | 188 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 149.3 KiB |
| Minimum | 2023-03-01 00:00:00 |
|---|---|
| Maximum | 2024-01-26 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
arrival_time
Unsupported
Rejected Unsupported
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 895.3 KiB |
from_to_location
Text
| Distinct | 119 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | BMV - SGN |
|---|---|
| 2nd row | BMV - SGN |
| 3rd row | HUI - SGN |
| 4th row | HUI - SGN |
| 5th row | HUI - SGN |
| Value | Count | Frequency (%) |
| 19096 | ||
| sgn | 14897 | |
| han | 5878 | 10.3% |
| dad | 3259 | 5.7% |
| cxr | 2924 | 5.1% |
| dli | 1866 | 3.3% |
| bmv | 1661 | 2.9% |
| pxu | 1243 | 2.2% |
| hui | 961 | 1.7% |
| vii | 885 | 1.5% |
| Other values (13) | 4618 | 8.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 38192 | ||
| N | 20777 | |
| - | 19096 | |
| S | 15028 | 8.7% |
| G | 14908 | 8.7% |
| H | 9652 | 5.6% |
| A | 9405 | 5.5% |
| D | 9026 | 5.3% |
| I | 5431 | 3.2% |
| C | 4892 | 2.8% |
| Other values (12) | 25457 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 171864 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 38192 | ||
| N | 20777 | |
| - | 19096 | |
| S | 15028 | 8.7% |
| G | 14908 | 8.7% |
| H | 9652 | 5.6% |
| A | 9405 | 5.5% |
| D | 9026 | 5.3% |
| I | 5431 | 3.2% |
| C | 4892 | 2.8% |
| Other values (12) | 25457 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 171864 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 38192 | ||
| N | 20777 | |
| - | 19096 | |
| S | 15028 | 8.7% |
| G | 14908 | 8.7% |
| H | 9652 | 5.6% |
| A | 9405 | 5.5% |
| D | 9026 | 5.3% |
| I | 5431 | 3.2% |
| C | 4892 | 2.8% |
| Other values (12) | 25457 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 171864 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 38192 | ||
| N | 20777 | |
| - | 19096 | |
| S | 15028 | 8.7% |
| G | 14908 | 8.7% |
| H | 9652 | 5.6% |
| A | 9405 | 5.5% |
| D | 9026 | 5.3% |
| I | 5431 | 3.2% |
| C | 4892 | 2.8% |
| Other values (12) | 25457 |
from_to
Text
| Distinct | 115 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.5 MiB |
Length
| Max length | 29 |
|---|---|
| Median length | 27 |
| Mean length | 21.07855 |
| Min length | 16 |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Đắk Lắk - Hồ Chí Minh |
|---|---|
| 2nd row | Đắk Lắk - Hồ Chí Minh |
| 3rd row | Thừa Thiên Huế - Hồ Chí Minh |
| 4th row | Thừa Thiên Huế - Hồ Chí Minh |
| 5th row | Thừa Thiên Huế - Hồ Chí Minh |
| Value | Count | Frequency (%) |
| 19096 | ||
| chí | 14897 | |
| hồ | 14897 | |
| minh | 14897 | |
| hà | 5878 | 5.3% |
| nội | 5878 | 5.3% |
| đà | 3259 | 2.9% |
| nẵng | 3259 | 2.9% |
| khánh | 2924 | 2.6% |
| hòa | 2924 | 2.6% |
| Other values (33) | 23560 |
Most occurring characters
| Value | Count | Frequency (%) |
| 92373 | ||
| h | 42438 | |
| n | 31459 | 7.8% |
| i | 26612 | 6.6% |
| H | 25599 | 6.4% |
| - | 19227 | 4.8% |
| ồ | 16763 | 4.2% |
| C | 15165 | 3.8% |
| M | 14903 | 3.7% |
| í | 14897 | 3.7% |
| Other values (37) | 103080 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 402516 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 92373 | ||
| h | 42438 | |
| n | 31459 | 7.8% |
| i | 26612 | 6.6% |
| H | 25599 | 6.4% |
| - | 19227 | 4.8% |
| ồ | 16763 | 4.2% |
| C | 15165 | 3.8% |
| M | 14903 | 3.7% |
| í | 14897 | 3.7% |
| Other values (37) | 103080 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 402516 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 92373 | ||
| h | 42438 | |
| n | 31459 | 7.8% |
| i | 26612 | 6.6% |
| H | 25599 | 6.4% |
| - | 19227 | 4.8% |
| ồ | 16763 | 4.2% |
| C | 15165 | 3.8% |
| M | 14903 | 3.7% |
| í | 14897 | 3.7% |
| Other values (37) | 103080 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 402516 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 92373 | ||
| h | 42438 | |
| n | 31459 | 7.8% |
| i | 26612 | 6.6% |
| H | 25599 | 6.4% |
| - | 19227 | 4.8% |
| ồ | 16763 | 4.2% |
| C | 15165 | 3.8% |
| M | 14903 | 3.7% |
| í | 14897 | 3.7% |
| Other values (37) | 103080 |
airline
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| Ry/OjEDP12vfMWbnat5Mudc3PE4qIK/wwfCkBE5zGlM= | |
|---|---|
| V2Ej16fVems7wWmAIxP6MCYYH+i4YSHlvuJgKvD2q8A= | |
| z7BiGsH86CZWRj0PbuuLk/5jh7XcwKSaa21M2royGnA= | |
| 73SByZiBulQv8bk/PGRtuNIpW3R+36DZ9nM31hDpDMQ= | 1158 |
Length
| Max length | 44 |
|---|---|
| Median length | 44 |
| Mean length | 44 |
| Min length | 44 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Ry/OjEDP12vfMWbnat5Mudc3PE4qIK/wwfCkBE5zGlM= |
|---|---|
| 2nd row | Ry/OjEDP12vfMWbnat5Mudc3PE4qIK/wwfCkBE5zGlM= |
| 3rd row | Ry/OjEDP12vfMWbnat5Mudc3PE4qIK/wwfCkBE5zGlM= |
| 4th row | Ry/OjEDP12vfMWbnat5Mudc3PE4qIK/wwfCkBE5zGlM= |
| 5th row | Ry/OjEDP12vfMWbnat5Mudc3PE4qIK/wwfCkBE5zGlM= |
Common Values
| Value | Count | Frequency (%) |
| Ry/OjEDP12vfMWbnat5Mudc3PE4qIK/wwfCkBE5zGlM= | 12519 | |
| V2Ej16fVems7wWmAIxP6MCYYH+i4YSHlvuJgKvD2q8A= | 3489 | 18.3% |
| z7BiGsH86CZWRj0PbuuLk/5jh7XcwKSaa21M2royGnA= | 1930 | 10.1% |
| 73SByZiBulQv8bk/PGRtuNIpW3R+36DZ9nM31hDpDMQ= | 1158 | 6.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| ry/ojedp12vfmwbnat5mudc3pe4qik/wwfckbe5zglm | 12519 | |
| v2ej16fvems7wwmaixp6mcyyh+i4yshlvujgkvd2q8a | 3489 | 18.3% |
| z7bigsh86czwrj0pbuulk/5jh7xcwksaa21m2roygna | 1930 | 10.1% |
| 73sbyzibulqv8bk/pgrtunipw3r+36dz9nm31hdpdmq | 1158 | 6.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 45292 | 5.4% |
| E | 41046 | 4.9% |
| P | 31615 | 3.8% |
| w | 30457 | 3.6% |
| f | 28527 | 3.4% |
| / | 28126 | 3.3% |
| 5 | 26968 | 3.2% |
| 2 | 23357 | 2.8% |
| u | 22184 | 2.6% |
| v | 20655 | 2.5% |
| Other values (52) | 541997 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 840224 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| M | 45292 | 5.4% |
| E | 41046 | 4.9% |
| P | 31615 | 3.8% |
| w | 30457 | 3.6% |
| f | 28527 | 3.4% |
| / | 28126 | 3.3% |
| 5 | 26968 | 3.2% |
| 2 | 23357 | 2.8% |
| u | 22184 | 2.6% |
| v | 20655 | 2.5% |
| Other values (52) | 541997 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 840224 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| M | 45292 | 5.4% |
| E | 41046 | 4.9% |
| P | 31615 | 3.8% |
| w | 30457 | 3.6% |
| f | 28527 | 3.4% |
| / | 28126 | 3.3% |
| 5 | 26968 | 3.2% |
| 2 | 23357 | 2.8% |
| u | 22184 | 2.6% |
| v | 20655 | 2.5% |
| Other values (52) | 541997 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 840224 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| M | 45292 | 5.4% |
| E | 41046 | 4.9% |
| P | 31615 | 3.8% |
| w | 30457 | 3.6% |
| f | 28527 | 3.4% |
| / | 28126 | 3.3% |
| 5 | 26968 | 3.2% |
| 2 | 23357 | 2.8% |
| u | 22184 | 2.6% |
| v | 20655 | 2.5% |
| Other values (52) | 541997 |
seat_class
Text
| Distinct | 69 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 120 |
| Missing (%) | 0.6% |
| Memory size | 1012.5 KiB |
Length
| Max length | 15 |
|---|---|
| Median length | 6 |
| Mean length | 5.4256429 |
| Min length | 1 |
Unique
| Unique | 8 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | I1_ECO |
|---|---|
| 2nd row | Z1_ECO |
| 3rd row | J1_ECO |
| 4th row | J1_ECO |
| 5th row | J1_ECO |
| Value | Count | Frequency (%) |
| e1_eco | 3163 | |
| a1_eco | 2652 | |
| z1_eco | 2608 | |
| economysaver | 1622 | 8.5% |
| w1_eco | 1269 | 6.7% |
| u1_eco | 826 | 4.4% |
| e | 784 | 4.1% |
| j1_eco | 709 | 3.7% |
| a | 632 | 3.3% |
| p | 595 | 3.1% |
| Other values (59) | 4116 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 18350 | |
| C | 12629 | |
| O | 12528 | |
| _ | 12519 | |
| 1 | 12515 | |
| o | 3832 | 3.7% |
| A | 3303 | 3.2% |
| Z | 2614 | 2.5% |
| m | 2154 | 2.1% |
| n | 1930 | 1.9% |
| Other values (34) | 20583 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 102957 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 18350 | |
| C | 12629 | |
| O | 12528 | |
| _ | 12519 | |
| 1 | 12515 | |
| o | 3832 | 3.7% |
| A | 3303 | 3.2% |
| Z | 2614 | 2.5% |
| m | 2154 | 2.1% |
| n | 1930 | 1.9% |
| Other values (34) | 20583 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 102957 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 18350 | |
| C | 12629 | |
| O | 12528 | |
| _ | 12519 | |
| 1 | 12515 | |
| o | 3832 | 3.7% |
| A | 3303 | 3.2% |
| Z | 2614 | 2.5% |
| m | 2154 | 2.1% |
| n | 1930 | 1.9% |
| Other values (34) | 20583 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 102957 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 18350 | |
| C | 12629 | |
| O | 12528 | |
| _ | 12519 | |
| 1 | 12515 | |
| o | 3832 | 3.7% |
| A | 3303 | 3.2% |
| Z | 2614 | 2.5% |
| m | 2154 | 2.1% |
| n | 1930 | 1.9% |
| Other values (34) | 20583 |
ticket_price
Real number (ℝ)
| Distinct | 2357 |
|---|---|
| Distinct (%) | 12.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1044120.7 |
| Minimum | 3000 |
|---|---|
| Maximum | 9010800 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 149.3 KiB |
Quantile statistics
| Minimum | 3000 |
|---|---|
| 5-th percentile | 553600 |
| Q1 | 737520 |
| median | 956800 |
| Q3 | 1255100 |
| 95-th percentile | 1825200 |
| Maximum | 9010800 |
| Range | 9007800 |
| Interquartile range (IQR) | 517580 |
Descriptive statistics
| Standard deviation | 468967.61 |
|---|---|
| Coefficient of variation (CV) | 0.44915075 |
| Kurtosis | 29.040846 |
| Mean | 1044120.7 |
| Median Absolute Deviation (MAD) | 236370 |
| Skewness | 2.9618958 |
| Sum | 1.993853 × 1010 |
| Variance | 2.1993062 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 553600 | 293 | 1.5% |
| 830400 | 259 | 1.4% |
| 622800 | 242 | 1.3% |
| 692000 | 237 | 1.2% |
| 761200 | 236 | 1.2% |
| 811900 | 211 | 1.1% |
| 730710 | 184 | 1.0% |
| 893090 | 181 | 0.9% |
| 974280 | 177 | 0.9% |
| 649520 | 175 | 0.9% |
| Other values (2347) | 16901 |
| Value | Count | Frequency (%) |
| 3000 | 1 | < 0.1% |
| 3300 | 3 | |
| 3600 | 1 | < 0.1% |
| 11700 | 1 | < 0.1% |
| 13500 | 1 | < 0.1% |
| 13600 | 2 | < 0.1% |
| 15600 | 1 | < 0.1% |
| 17000 | 1 | < 0.1% |
| 19800 | 1 | < 0.1% |
| 24300 | 5 |
| Value | Count | Frequency (%) |
| 9010800 | 1 | |
| 9009600 | 1 | |
| 8459000 | 1 | |
| 8259900 | 1 | |
| 7613100 | 1 | |
| 7196400 | 1 | |
| 6988800 | 1 | |
| 6947100 | 1 | |
| 6767200 | 1 | |
| 6758100 | 1 |
baggage
Real number (ℝ)
Zeros
| Distinct | 63 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20216.395 |
| Minimum | -90000 |
|---|---|
| Maximum | 831600 |
| Zeros | 17290 |
| Zeros (%) | 90.5% |
| Negative | 2 |
| Negative (%) | < 0.1% |
| Memory size | 149.3 KiB |
Quantile statistics
| Minimum | -90000 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 198000 |
| Maximum | 831600 |
| Range | 921600 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 66560.501 |
|---|---|
| Coefficient of variation (CV) | 3.2924021 |
| Kurtosis | 15.648474 |
| Mean | 20216.395 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.6432106 |
| Sum | 3.8605227 × 108 |
| Variance | 4.4303002 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 17290 | |
| 198000 | 275 | 1.4% |
| 237600 | 268 | 1.4% |
| 158400 | 263 | 1.4% |
| 217800 | 260 | 1.4% |
| 178200 | 256 | 1.3% |
| 297000 | 48 | 0.3% |
| 356400 | 43 | 0.2% |
| 326700 | 23 | 0.1% |
| 220000 | 23 | 0.1% |
| Other values (53) | 347 | 1.8% |
| Value | Count | Frequency (%) |
| -90000 | 2 | < 0.1% |
| 0 | 17290 | |
| 69300 | 1 | < 0.1% |
| 77000 | 1 | < 0.1% |
| 88000 | 17 | 0.1% |
| 92400 | 3 | < 0.1% |
| 99000 | 10 | 0.1% |
| 105600 | 9 | < 0.1% |
| 108000 | 1 | < 0.1% |
| 110000 | 13 | 0.1% |
| Value | Count | Frequency (%) |
| 831600 | 1 | < 0.1% |
| 762300 | 1 | < 0.1% |
| 712800 | 1 | < 0.1% |
| 693000 | 3 | |
| 653400 | 2 | |
| 620400 | 1 | < 0.1% |
| 594000 | 1 | < 0.1% |
| 554400 | 1 | < 0.1% |
| 544500 | 1 | < 0.1% |
| 534600 | 1 | < 0.1% |
insurance_fee
Real number (ℝ)
Skewed Zeros
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 98.973508 |
| Minimum | -60000 |
|---|---|
| Maximum | 60000 |
| Zeros | 19053 |
| Zeros (%) | 99.8% |
| Negative | 3 |
| Negative (%) | < 0.1% |
| Memory size | 149.3 KiB |
Quantile statistics
| Minimum | -60000 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 60000 |
| Range | 120000 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2289.7353 |
|---|---|
| Coefficient of variation (CV) | 23.13483 |
| Kurtosis | 494.25637 |
| Mean | 98.973508 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 20.200008 |
| Sum | 1889998.1 |
| Variance | 5242887.7 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 0 | 19053 | |
| 50000 | 14 | 0.1% |
| 40000 | 9 | < 0.1% |
| 45000 | 7 | < 0.1% |
| 60000 | 5 | < 0.1% |
| 55000 | 5 | < 0.1% |
| -60000 | 1 | < 0.1% |
| -1.1 | 1 | < 0.1% |
| -0.8 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| -60000 | 1 | < 0.1% |
| -1.1 | 1 | < 0.1% |
| -0.8 | 1 | < 0.1% |
| 0 | 19053 | |
| 40000 | 9 | < 0.1% |
| 45000 | 7 | < 0.1% |
| 50000 | 14 | 0.1% |
| 55000 | 5 | < 0.1% |
| 60000 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 60000 | 5 | < 0.1% |
| 55000 | 5 | < 0.1% |
| 50000 | 14 | 0.1% |
| 45000 | 7 | < 0.1% |
| 40000 | 9 | < 0.1% |
| 0 | 19053 | |
| -0.8 | 1 | < 0.1% |
| -1.1 | 1 | < 0.1% |
| -60000 | 1 | < 0.1% |
discount_amount
Real number (ℝ)
High correlation Zeros
| Distinct | 13 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24360.861 |
| Minimum | -24000 |
|---|---|
| Maximum | 60000 |
| Zeros | 6561 |
| Zeros (%) | 34.4% |
| Negative | 2 |
| Negative (%) | < 0.1% |
| Memory size | 149.3 KiB |
Quantile statistics
| Minimum | -24000 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 20000 |
| Q3 | 45000 |
| 95-th percentile | 60000 |
| Maximum | 60000 |
| Range | 84000 |
| Interquartile range (IQR) | 45000 |
Descriptive statistics
| Standard deviation | 21824.077 |
|---|---|
| Coefficient of variation (CV) | 0.89586643 |
| Kurtosis | -1.4166822 |
| Mean | 24360.861 |
| Median Absolute Deviation (MAD) | 20000 |
| Skewness | 0.26141733 |
| Sum | 4.65195 × 108 |
| Variance | 4.7629035 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=13)
| Value | Count | Frequency (%) |
| 0 | 6561 | |
| 40000 | 1467 | 7.7% |
| 60000 | 1455 | 7.6% |
| 50000 | 1427 | 7.5% |
| 45000 | 1425 | 7.5% |
| 55000 | 1386 | 7.3% |
| 22000 | 1126 | 5.9% |
| 18000 | 1118 | 5.9% |
| 24000 | 1059 | 5.5% |
| 16000 | 1040 | 5.4% |
| Other values (3) | 1032 | 5.4% |
| Value | Count | Frequency (%) |
| -24000 | 1 | < 0.1% |
| -18000 | 1 | < 0.1% |
| 0 | 6561 | |
| 16000 | 1040 | 5.4% |
| 18000 | 1118 | 5.9% |
| 20000 | 1030 | 5.4% |
| 22000 | 1126 | 5.9% |
| 24000 | 1059 | 5.5% |
| 40000 | 1467 | 7.7% |
| 45000 | 1425 | 7.5% |
| Value | Count | Frequency (%) |
| 60000 | 1455 | |
| 55000 | 1386 | |
| 50000 | 1427 | |
| 45000 | 1425 | |
| 40000 | 1467 | |
| 24000 | 1059 | |
| 22000 | 1126 | |
| 20000 | 1030 | |
| 18000 | 1118 | |
| 16000 | 1040 |
Interactions
Correlations
| airline | baggage | discount_amount | insurance_fee | order_id | passenger_age | passenger_gender | ticket_id | ticket_price | ticket_source_name | ticket_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| airline | 1.000 | 0.069 | 0.293 | 0.009 | 0.092 | 0.000 | 0.039 | 0.094 | 0.131 | 0.034 | 0.070 |
| baggage | 0.069 | 1.000 | 0.026 | 0.002 | 0.010 | -0.004 | 0.035 | 0.010 | 0.052 | 0.007 | 0.067 |
| discount_amount | 0.293 | 0.026 | 1.000 | -0.018 | -0.503 | 0.018 | 0.024 | -0.503 | -0.177 | 0.020 | 0.055 |
| insurance_fee | 0.009 | 0.002 | -0.018 | 1.000 | -0.007 | 0.006 | 0.000 | -0.007 | 0.005 | 0.000 | 0.000 |
| order_id | 0.092 | 0.010 | -0.503 | -0.007 | 1.000 | -0.080 | 0.039 | 1.000 | -0.076 | 0.075 | 0.085 |
| passenger_age | 0.000 | -0.004 | 0.018 | 0.006 | -0.080 | 1.000 | 0.000 | -0.080 | 0.133 | 0.007 | 0.000 |
| passenger_gender | 0.039 | 0.035 | 0.024 | 0.000 | 0.039 | 0.000 | 1.000 | 0.036 | 0.017 | 0.057 | 0.013 |
| ticket_id | 0.094 | 0.010 | -0.503 | -0.007 | 1.000 | -0.080 | 0.036 | 1.000 | -0.076 | 0.072 | 0.084 |
| ticket_price | 0.131 | 0.052 | -0.177 | 0.005 | -0.076 | 0.133 | 0.017 | -0.076 | 1.000 | 0.034 | 0.050 |
| ticket_source_name | 0.034 | 0.007 | 0.020 | 0.000 | 0.075 | 0.007 | 0.057 | 0.072 | 0.034 | 1.000 | 0.104 |
| ticket_status | 0.070 | 0.067 | 0.055 | 0.000 | 0.085 | 0.000 | 0.013 | 0.084 | 0.050 | 0.104 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| order_id | ticket_id | passenger_id | passenger_gender | passenger_age | ticket_source_name | ticket_status | created_date | departure_date | departure_time | arrival_date | arrival_time | from_to_location | from_to | airline | seat_class | ticket_price | baggage | insurance_fee | discount_amount | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 20205 | 31268 | Xs1fLinPQun+Oy/mD0FlfXMyJD38YlXJfXNbz+qO+5U= | Female | 40.0 | IOS | Paid | 2023-03-01 | 2023-03-14 | 17:55:00 | 2023-03-14 | 18:55:00 | BMV - SGN | Đắk Lắk - Hồ Chí Minh | Ry/OjEDP12vfMWbnat5Mudc3PE4qIK/wwfCkBE5zGlM= | I1_ECO | 867760 | 0 | 0.0 | 45000 |
| 1 | 20190 | 31242 | m/auVlEoaGSe2MqR/Lq4CFXJnI8zauNyF/KiFmMgXHs= | Female | 40.0 | GYL | Paid | 2023-03-01 | 2023-03-02 | 09:30:00 | 2023-03-02 | 10:30:00 | BMV - SGN | Đắk Lắk - Hồ Chí Minh | Ry/OjEDP12vfMWbnat5Mudc3PE4qIK/wwfCkBE5zGlM= | Z1_ECO | 974280 | 0 | 0.0 | 45000 |
| 2 | 20245 | 31337 | 6HvtV2vTqUfNBJ53C4TzvJnb0s74KgcRNuUVS+8jRvU= | Female | 48.0 | IOS | Paid | 2023-03-01 | 2023-04-10 | 13:10:00 | 2023-04-10 | 14:35:00 | HUI - SGN | Thừa Thiên Huế - Hồ Chí Minh | Ry/OjEDP12vfMWbnat5Mudc3PE4qIK/wwfCkBE5zGlM= | J1_ECO | 1423080 | 0 | 0.0 | 16000 |
| 3 | 20259 | 31360 | WiK2P31WEd4mckRNVWz0C2aKKRgSrauAG8NdfTLnKjE= | Male | 29.0 | Android | New | 2023-03-01 | 2023-04-10 | 13:10:00 | 2023-04-10 | 14:35:00 | HUI - SGN | Thừa Thiên Huế - Hồ Chí Minh | Ry/OjEDP12vfMWbnat5Mudc3PE4qIK/wwfCkBE5zGlM= | J1_ECO | 1067310 | 0 | 0.0 | 45000 |
| 4 | 20255 | 31355 | 6HvtV2vTqUfNBJ53C4TzvJnb0s74KgcRNuUVS+8jRvU= | Female | 42.0 | IOS | Paid | 2023-03-01 | 2023-04-10 | 13:10:00 | 2023-04-10 | 14:35:00 | HUI - SGN | Thừa Thiên Huế - Hồ Chí Minh | Ry/OjEDP12vfMWbnat5Mudc3PE4qIK/wwfCkBE5zGlM= | J1_ECO | 1067310 | 0 | 0.0 | 24000 |
| 5 | 20251 | 31348 | 6HvtV2vTqUfNBJ53C4TzvJnb0s74KgcRNuUVS+8jRvU= | Female | 42.0 | IOS | Paid | 2023-03-01 | 2023-04-10 | 13:10:00 | 2023-04-10 | 14:35:00 | HUI - SGN | Thừa Thiên Huế - Hồ Chí Minh | Ry/OjEDP12vfMWbnat5Mudc3PE4qIK/wwfCkBE5zGlM= | J1_ECO | 1304490 | 0 | 0.0 | 16000 |
| 6 | 20226 | 31307 | WiK2P31WEd4mckRNVWz0C2aKKRgSrauAG8NdfTLnKjE= | Male | 29.0 | Android | New | 2023-03-01 | 2023-04-10 | 13:10:00 | 2023-04-10 | 14:35:00 | HUI - SGN | Thừa Thiên Huế - Hồ Chí Minh | Ry/OjEDP12vfMWbnat5Mudc3PE4qIK/wwfCkBE5zGlM= | J1_ECO | 1304490 | 0 | 0.0 | 0 |
| 7 | 20251 | 31344 | 6HvtV2vTqUfNBJ53C4TzvJnb0s74KgcRNuUVS+8jRvU= | Female | 49.0 | IOS | Paid | 2023-03-01 | 2023-04-10 | 13:10:00 | 2023-04-10 | 14:35:00 | HUI - SGN | Thừa Thiên Huế - Hồ Chí Minh | Ry/OjEDP12vfMWbnat5Mudc3PE4qIK/wwfCkBE5zGlM= | J1_ECO | 948720 | 0 | 40000.0 | 18000 |
| 8 | 20251 | 31346 | 6HvtV2vTqUfNBJ53C4TzvJnb0s74KgcRNuUVS+8jRvU= | Female | 22.0 | IOS | Paid | 2023-03-01 | 2023-04-10 | 13:10:00 | 2023-04-10 | 14:35:00 | HUI - SGN | Thừa Thiên Huế - Hồ Chí Minh | Ry/OjEDP12vfMWbnat5Mudc3PE4qIK/wwfCkBE5zGlM= | J1_ECO | 948720 | 0 | 0.0 | 24000 |
| 9 | 20251 | 31350 | 6HvtV2vTqUfNBJ53C4TzvJnb0s74KgcRNuUVS+8jRvU= | Male | 7.0 | IOS | Paid | 2023-03-01 | 2023-04-10 | 13:10:00 | 2023-04-10 | 14:35:00 | HUI - SGN | Thừa Thiên Huế - Hồ Chí Minh | Ry/OjEDP12vfMWbnat5Mudc3PE4qIK/wwfCkBE5zGlM= | J1_ECO | 1013310 | 0 | 0.0 | 24000 |
| order_id | ticket_id | passenger_id | passenger_gender | passenger_age | ticket_source_name | ticket_status | created_date | departure_date | departure_time | arrival_date | arrival_time | from_to_location | from_to | airline | seat_class | ticket_price | baggage | insurance_fee | discount_amount | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19086 | 33909 | 52710 | 61HLhjosTIRPTMqSCq6/bE3+3Bhj6tiXwRrXBqeNoAM= | Female | 28.0 | IOS | New | 2023-05-31 | 2023-06-11 | 17:40:00 | 2023-06-11 | 19:30:00 | VDH - SGN | Quảng Bình - Hồ Chí Minh | V2Ej16fVems7wWmAIxP6MCYYH+i4YSHlvuJgKvD2q8A= | Q | 2137200 | 0 | 0.0 | 0 |
| 19087 | 33910 | 52714 | sAAP06aa+4i71WPrsr3K7AiVtBIZHkX/ZEwVVFIzc+E= | Female | 28.0 | IOS | Paid | 2023-05-31 | 2023-06-11 | 17:40:00 | 2023-06-11 | 19:30:00 | VDH - SGN | Quảng Bình - Hồ Chí Minh | V2Ej16fVems7wWmAIxP6MCYYH+i4YSHlvuJgKvD2q8A= | Q | 1602900 | 0 | 0.0 | 0 |
| 19088 | 33919 | 52727 | sMLGVyQ7cfMOpCM6c63F8aCfz9Xdn/Rc0E0VqRZEWwQ= | Male | 28.0 | IOS | New | 2023-05-31 | 2023-06-12 | 12:35:00 | 2023-06-12 | 13:45:00 | DLI - SGN | Lâm Đồng - Hồ Chí Minh | V2Ej16fVems7wWmAIxP6MCYYH+i4YSHlvuJgKvD2q8A= | R | 1436600 | 0 | 0.0 | 0 |
| 19089 | 33856 | 52632 | 7MHTyxXVgw06aWI7UyjJojbXcNSAZ7IVQKKPA3OC4ZM= | Female | 29.0 | GYL | Cancel | 2023-05-31 | 2023-06-15 | 07:55:00 | 2023-06-15 | 09:35:00 | DLI - SGN | Lâm Đồng - Hồ Chí Minh | V2Ej16fVems7wWmAIxP6MCYYH+i4YSHlvuJgKvD2q8A= | A | 668000 | 237600 | 0.0 | 0 |
| 19090 | 33900 | 52697 | 8NMW+DtI8tKi5qcf2nZvqHJUhvC5Ic4063AvCJXGIys= | Female | 54.0 | GYL | Paid | 2023-05-31 | 2023-06-02 | 07:55:00 | 2023-06-02 | 09:35:00 | DLI - SGN | Lâm Đồng - Hồ Chí Minh | V2Ej16fVems7wWmAIxP6MCYYH+i4YSHlvuJgKvD2q8A= | A | 660600 | 0 | 0.0 | 0 |
| 19091 | 33900 | 52696 | 8NMW+DtI8tKi5qcf2nZvqHJUhvC5Ic4063AvCJXGIys= | Male | 58.0 | GYL | Paid | 2023-05-31 | 2023-06-02 | 07:55:00 | 2023-06-02 | 09:35:00 | DLI - SGN | Lâm Đồng - Hồ Chí Minh | V2Ej16fVems7wWmAIxP6MCYYH+i4YSHlvuJgKvD2q8A= | A | 807400 | 0 | 0.0 | 0 |
| 19092 | 33907 | 52705 | 7MHTyxXVgw06aWI7UyjJojbXcNSAZ7IVQKKPA3OC4ZM= | Female | 29.0 | Android | Cancel | 2023-05-31 | 2023-06-10 | 07:55:00 | 2023-06-10 | 09:35:00 | DLI - SGN | Lâm Đồng - Hồ Chí Minh | V2Ej16fVems7wWmAIxP6MCYYH+i4YSHlvuJgKvD2q8A= | E | 910000 | 158400 | 0.0 | 0 |
| 19093 | 33854 | 52630 | 7MHTyxXVgw06aWI7UyjJojbXcNSAZ7IVQKKPA3OC4ZM= | Female | 29.0 | GYL | New | 2023-05-31 | 2023-06-15 | 07:55:00 | 2023-06-15 | 09:35:00 | DLI - SGN | Lâm Đồng - Hồ Chí Minh | V2Ej16fVems7wWmAIxP6MCYYH+i4YSHlvuJgKvD2q8A= | A | 534400 | 0 | 0.0 | 0 |
| 19094 | 33882 | 52668 | qUmeTJy0TEYBaZ6h6A+DRzmuD2SfdhcGxwsYUDGRpc8= | Female | 25.0 | Android | Cancel | 2023-05-31 | 2023-06-02 | 15:30:00 | 2023-06-02 | 16:25:00 | DLI - SGN | Lâm Đồng - Hồ Chí Minh | V2Ej16fVems7wWmAIxP6MCYYH+i4YSHlvuJgKvD2q8A= | T | 1109900 | 0 | 0.0 | 0 |
| 19095 | 33882 | 52669 | qUmeTJy0TEYBaZ6h6A+DRzmuD2SfdhcGxwsYUDGRpc8= | Female | 50.0 | Android | Cancel | 2023-05-31 | 2023-06-02 | 15:30:00 | 2023-06-02 | 16:25:00 | DLI - SGN | Lâm Đồng - Hồ Chí Minh | V2Ej16fVems7wWmAIxP6MCYYH+i4YSHlvuJgKvD2q8A= | T | 1109900 | 0 | 0.0 | 0 |